safari ITP

ツールベンダー（ この場合は google) から対応の可能性

なければ、自分で、local storage設定かな..

safari 12.1 からの話

12.1のrelease date を調べたけど、でてこない.

ITP 2.1 was announced of February 21st, 2019, and it will come to effect as soon as iOS 12.2 and Safari 12.1 come out of beta. I’ve heard rumors this would be sometime in March before the Apple event.

８日以上経過したと記録されるセッションはまだあるようだが、

ITP2.1より前に作られたcookieについては、safari 12.1でも適用除外？なのかな？

safariのverionが上がっても、fullvisitorIdが同じものはそれなりにあるので、versionが上がるたびに、新規セッションになることはないと思ってるが、、

たしかに新規のセッション率はあがってるけど、、

browserのfinger printingによる推定も排除する方針と。

Objective: If you provide a service that other sites consume such as widgets, embedded content, affiliate programmes, advertising, or sign-in across multiple sites then you should use None to ensure your intent is clear.

then you need to declare that to the browser and the user by marking them as SameSite=None

code: safariのバージョン上がってもcookieは継続.sql

SELECT

brw,

brw_c,

a.c,

COUNT(a.c) as cnt

FROM (

SELECT

COUNT(DISTINCT device.browserversion) AS c,

string_agg(DISTINCT device.browserversion) AS brw_c,

string_agg(distinct device.browser) AS brw

FROM

xxxxxx.ga_sessions_201905*

GROUP BY

fullvisitorid

) AS a

where a.brw = "Safari"

GROUP BY

a.c,

brw,brw_c

order by cnt desc

code: 間隔日数.sql

with a as (

SELECT

date, fullvisitorid,

row_number() over(partition by fullvisitorid order by visitstarttime) as num,

visitstarttime - lag(visitstarttime) over(partition by fullvisitorid order by visitstarttime) as elapsed

,device.browser, device.browserversion

FROM

xxxxx.ga_sessions_201905*

)

select *, elapsed/(60*60*24) as day from a

where num > 1 and browser = "Safari" and elapsed/(60*60*24) > 2

order by fullvisitorid, num